The code was derived from work by the DSI. This analysis seeks to model % of tests positive using wastewater Data. This model has logical reasons to be predictive but only finds moderate success when broken down by collection site. Particularly it consistently underpredicts the % positive rate in the P2 district.
The Original R code file can be found in the [pandemic github repository](https://github.com/UW-Madison-DataScience/pandemic/blob/master/wastewater.Rmd).
The Code for this R File can be found in the [Marlin Lee waste Water Work](https://github.com/MarlinRLee/Covid-Waste-Water-Exploration/blob/main/general%20model%20finding.Rmd)

## # A tibble: 3 x 3
##   Date       CovRatio PMMoVRatio
##   <chr>         <dbl>      <dbl>
## 1 2020-12-15    1.13        2.96
## 2 2020-12-22    0.814       2.66
## 3 2021-02-18    1.30        2.21
## # A tibble: 3 x 3
##   Date       CovRatio PMMoVRatio
##   <chr>         <dbl>      <dbl>
## 1 2020-10-26    1.80      0.358 
## 2 2020-11-16    0.326     0.0883
## 3 2021-02-08    0.645     0.0607
## # A tibble: 3 x 3
##   Date       CovRatio PMMoVRatio
##   <chr>         <dbl>      <dbl>
## 1 2021-02-04     7.94      0.879
## 2 2020-11-30     3.47      0.913
## 3 2021-02-11     2.08      1.15
## # A tibble: 3 x 3
##   Date       CovRatio PMMoVRatio
##   <chr>         <dbl>      <dbl>
## 1 2020-11-16    0.326     0.0883
## 2 2020-11-09    0.134     0.566 
## 3 2021-02-01    0.126     0.970
##    Min. 1st Qu.  Median    Mean 3rd Qu.    Max. 
## 0.06071 0.88396 1.01148 1.08913 1.20287 2.95839
##    Min. 1st Qu.  Median    Mean 3rd Qu.    Max. 
##   0.126   0.703   0.861   1.122   1.112   7.935

Analysis with old data

## # A tibble: 3 x 2
##   Date       CovRatio
##   <chr>         <dbl>
## 1 2020-10-26     1.73
## 2 2020-10-06     1.70
## 3 2020-11-23     1.58
## # A tibble: 3 x 2
##   Date       CovRatio
##   <chr>         <dbl>
## 1 2020-11-16    0.432
## 2 2020-09-29    0.219
## 3 2020-11-09    0.135
## # A tibble: 3 x 2
##   Date       CovRatioN1
##   <chr>           <dbl>
## 1 2020-10-26       1.73
## 2 2020-10-06       1.59
## 3 2020-11-23       1.30
## # A tibble: 3 x 2
##   Date       CovRatioN1
##   <chr>           <dbl>
## 1 2020-09-29      0.399
## 2 2020-11-16      0.326
## 3 2020-11-09      0.131
## # A tibble: 3 x 2
##   Date       CovRatioN2
##   <chr>           <dbl>
## 1 2020-10-06      1.73 
## 2 2020-11-23      1.67 
## 3 2020-11-17      0.723
## # A tibble: 3 x 2
##   Date       CovRatioN2
##   <chr>           <dbl>
## 1 2020-09-28      0.549
## 2 2020-11-24      0.530
## 3 2020-09-29      0.120
##    Min. 1st Qu.  Median    Mean 3rd Qu.    Max. 
##  0.1353  0.5588  0.7004  0.8040  0.8177  1.7299
##    Min. 1st Qu.  Median    Mean 3rd Qu.    Max. 
##  0.1312  0.4889  0.8434  0.8451  1.0915  1.7299
##    Min. 1st Qu.  Median    Mean 3rd Qu.    Max.    NA's 
##  0.1203  0.5490  0.6134  0.7980  0.7233  1.7308       9